{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INFO","Urlaubsplaner","Urlaubsantrag","AbteilungMonat","Ferientage","Daten","Import"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INFO","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,2,13,4],[15,2,29,4]]}
[]
[]
[null,null,"Zur vollen Funktionalität dieser Arbeitsmappe müssen die Makros aktiviert sein. Bei Fragen hierzu bedienen Sie sich bitte der Excel-Hilfe.\n\nVielen Dank!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Aktuelle (gewünschte) Neuerungen:\n\nDie Schulferien für das Jahr 2024 wurden für alle Bundesländer eingepflegt.\n\nFolgende Feiertage wurden eingepflegt:\nReformationstag für BB, HB, HH, MV, \nNI, SH, SN, ST, TH.\nFrauentag für BE und MV\n\nAktueller Upload vom 02.11.2023"]

{"sheet":"Urlaubsplaner","index":1,"n_rows":386,"n_cols":66,"rows_kept":386,"cut":false,"hidden":false,"merged":[[361,3,367,3],[368,3,374,3],[375,3,381,3],[214,3,220,3],[221,3,227,3],[228,3,234,3],[235,3,241,3],[242,3,248,3],[256,3,262,3],[263,3,269,3],[270,3,276,3],[277,3,283,3],[284,3,290,3],[291,3,297,3],[298,3,304,3],[305,3,311,3],[1,6,1,65],[2,6,2,15],[2,16,2,25],[2,46,2,55],[2,56,2,65],[2,36,2,45],[2,26,2,35],[1,1,2,2],[9,1,9,4],[1,3,2,4],[4,1,4,4],[5,1,5,4],[3,1,3,4],[7,1,7,4],[8,1,8,4],[6,1,6,4],[11,3,17,3],[18,3,24,3],[60,3,66,3],[67,3,73,3],[74,3,80,3],[25,3,31,3],[32,3,38,3],[39,3,45,3],[46,3,52,3],[53,3,59,3],[81,3,87,3],[88,3,94,3],[95,3,101,3],[102,3,108,3],[109,3,115,3],[116,3,122,3],[123,3,129,3],[130,3,136,3],[137,3,143,3],[144,3,150,3],[151,3,157,3],[158,3,164,3],[165,3,171,3],[172,3,178,3],[249,3,255,3],[179,3,185,3],[186,3,192,3],[193,3,199,3],[200,3,206,3],[207,3,213,3],[347,3,353,3],[354,3,360,3],[312,3,318,3],[319,3,325,3],[326,3,332,3],[333,3,339,3],[340,3,346,3]]}
[5]
[null,{"$f":"(B12)","v":"2024-01-01"},null,"NRW",null,2,{"$f":"\"Urlaubs- / Fehlzeitenplaner \"&YEAR(B12)","v":"Urlaubs- / Fehlzeitenplaner 2024"}]
[null,null,null,null,null,null,"Einkauf",null,null,null,null,null,null,null,null,null,"Verkauf",null,null,null,null,null,null,null,null,null,"Konstruktion",null,null,null,null,null,null,null,null,null,"Kalkulation",null,null,null,null,null,null,null,null,null,"Buchhaltung",null,null,null,null,null,null,null,null,null,"Fertigung"]
[null,"Tarifurlaub + Resturl. Vorjahr",null,null,null,null,30.5,40]
[null,"Ist-Urlaub",null,null,null,null,{"$f":"COUNTIF(G12:G377,\"U\")+COUNTIF(G12:G377,\"U½\")/2","v":10},10,0,0,0,0,0,0,0,{"$f":"COUNTIF(P12:P377,\"U\")+COUNTIF(P12:P377,\"U½\")/2","v":0},0,{"$f":"COUNTIF(R12:R377,\"U\")+COUNTIF(R12:R377,\"U½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AB12:AB377,\"U\")+COUNTIF(AB12:AB377,\"U½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AL12:AL377,\"U\")+COUNTIF(AL12:AL377,\"U½\")/2","v":0},0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AU12:AU377,\"U\")+COUNTIF(AU12:AU377,\"U½\")/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Resturlaub",null,null,null,null,{"$f":"G4-G5","v":20.5},30,0,0,0,0,0,0,0,{"$f":"P4-P5","v":0},0,{"$f":"R4-R5","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AB4-AB5","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AL4-AL5","v":0},0,0,0,0,0,{"$f":"AR4-AR5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Frei-/Gleitzeitausgleich",null,null,null,null,{"$f":"COUNTIF(G12:G377,\"F\")+COUNTIF(G12:G377,\"F½\")/2","v":0},{"$f":"COUNTIF(H12:H377,\"F\")+COUNTIF(H12:H377,\"F½\")/2","v":0},{"$f":"COUNTIF(I12:I377,\"F\")+COUNTIF(I12:I377,\"F½\")/2","v":0},0,0,0,0,0,0,{"$f":"COUNTIF(P12:P377,\"F\")+COUNTIF(P12:P377,\"F½\")/2","v":0},{"$f":"COUNTIF(Q12:Q377,\"F\")+COUNTIF(Q12:Q377,\"F½\")/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AR12:AR377,\"F\")+COUNTIF(AR12:AR377,\"F½\")/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Weiterbildung/Seminar",null,null,null,null,{"$f":"COUNTIF(G12:G377,\"W\")+COUNTIF(G12:G377,\"W½\")/2","v":0},0,0,{"$f":"COUNTIF(J12:J377,\"W\")+COUNTIF(J12:J377,\"W½\")/2","v":0},0,0,0,0,0,{"$f":"COUNTIF(P12:P377,\"W\")+COUNTIF(P12:P377,\"W½\")/2","v":0},0,{"$f":"COUNTIF(R12:R377,\"W\")+COUNTIF(R12:R377,\"W½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AB12:AB377,\"W\")+COUNTIF(AB12:AB377,\"W½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AL12:AL377,\"W\")+COUNTIF(AL12:AL377,\"W½\")/2","v":0},0,0,0,0,0,{"$f":"COUNTIF(AR12:AR377,\"W\")+COUNTIF(AR12:AR377,\"W½\")/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Krankheitstage",null,null,null,null,{"$f":"COUNTIF(G12:G377,\"K\")+COUNTIF(G12:G377,\"K½\")/2","v":0},0,0,{"$f":"COUNTIF(J12:J377,\"K\")+COUNTIF(J12:J377,\"K½\")/2","v":0},0,0,0,0,0,{"$f":"COUNTIF(P12:P377,\"K\")+COUNTIF(P12:P377,\"K½\")/2","v":0},0,{"$f":"COUNTIF(R12:R377,\"K\")+COUNTIF(R12:R377,\"K½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AB12:AB377,\"K\")+COUNTIF(AB12:AB377,\"K½\")/2","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AL12:AL377,\"K\")+COUNTIF(AL12:AL377,\"K½\")/2","v":0},0,0,0,0,0,{"$f":"COUNTIF(AR12:AR377,\"K\")+COUNTIF(AR12:AR377,\"K½\")/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gesamtfehltage",null,null,null,null,{"$f":"SUM(G7:G9)","v":0},{"$f":"SUM(H7:H9)","v":0},0,{"$f":"SUM(J7:J9)","v":0},0,0,0,0,0,{"$f":"SUM(P7:P9)","v":0},0,{"$f":"SUM(R7:R9)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB7:AB9)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL7:AL9)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AV7:AV9)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF7:BF9)","v":0},0,0,0,0,0,0,0,0]
[null,"Datum","Tag","KW","Anzahl fehlender MA",null,"Beispiel, Sven","Beispiel, Tanja"]
[null,"2024-01-01",{"$f":"IF(WEEKDAY(B12)=1,\"Sonntag\",IF(WEEKDAY(B12)=2,\"Montag\",IF(WEEKDAY(B12)=3,\"Dienstag\",IF(WEEKDAY(B12)=4,\"Mittwoch\",IF(WEEKDAY(B12)=5,\"Donnerstag\",IF(WEEKDAY(B12)=6,\"Freitag\",\"Samstag\"))))))","v":"Montag"},1,{"$f":"COUNTIF(G12:KF12,\"*\")","v":0}]
[null,{"$f":"B12+1","v":"2024-01-02"},{"$f":"IF(WEEKDAY(B13)=1,\"Sonntag\",IF(WEEKDAY(B13)=2,\"Montag\",IF(WEEKDAY(B13)=3,\"Dienstag\",IF(WEEKDAY(B13)=4,\"Mittwoch\",IF(WEEKDAY(B13)=5,\"Donnerstag\",IF(WEEKDAY(B13)=6,\"Freitag\",\"Samstag\"))))))","v":"Dienstag"},null,0]
[null,"2024-01-03","Mittwoch",null,0]
[null,"2024-01-04","Donnerstag",null,0]
[null,"2024-01-05","Freitag",null,0]
[null,"2024-01-06","Samstag",null,0]
[null,"2024-01-07","Sonntag",null,0]
[null,"2024-01-08","Montag",2,1,null,null,"U"]
[null,"2024-01-09","Dienstag",null,1,null,null,"U"]
[null,"2024-01-10","Mittwoch",null,1,null,null,"U"]
[null,{"$f":"B21+1","v":"2024-01-11"},"Donnerstag",null,1,null,null,"U"]
[null,"2024-01-12","Freitag",null,1,null,null,"U"]
[null,"2024-01-13","Samstag",null,0]
[null,"2024-01-14","Sonntag",null,0]
[null,"2024-01-15","Montag",3,2,null,"U","U"]
[null,"2024-01-16","Dienstag",null,2,null,"U","U"]
[null,"2024-01-17","Mittwoch",null,2,null,"U","U"]
[null,"2024-01-18","Donnerstag",null,2,null,"U","U"]
[null,"2024-01-19","Freitag",null,2,null,"U","U"]
[null,"2024-01-20","Samstag",null,0]
[null,"2024-01-21","Sonntag",null,0]
[null,"2024-01-22","Montag",4,1,null,"U"]
[null,"2024-01-23","Dienstag",null,1,null,"U"]
[null,"2024-01-24","Mittwoch",null,1,null,"U"]
[null,"2024-01-25","Donnerstag",null,1,null,"U"]
[null,"2024-01-26","Freitag",null,1,null,"U"]
[null,"2024-01-27","Samstag",null,0]
[null,"2024-01-28","Sonntag",null,0]
[null,"2024-01-29","Montag",5,0]
[null,"2024-01-30","Dienstag",null,0]
[null,"2024-01-31","Mittwoch",null,0]
[null,"2024-02-01","Donnerstag",null,0]
[null,"2024-02-02","Freitag",null,0]
[null,"2024-02-03","Samstag",null,0]
[null,"2024-02-04","Sonntag",null,0]
[null,"2024-02-05","Montag",6,0]
[null,"2024-02-06","Dienstag",null,0]
[null,"2024-02-07","Mittwoch",null,0]
[null,"2024-02-08","Donnerstag",null,0]
[null,"2024-02-09","Freitag",null,0]
[null,"2024-02-10","Samstag",null,0]
[null,"2024-02-11","Sonntag",null,0]
[null,"2024-02-12","Montag",7,0]
[null,"2024-02-13","Dienstag",null,0]
[null,"2024-02-14","Mittwoch",null,0]
[null,"2024-02-15","Donnerstag",null,0]
[null,"2024-02-16","Freitag",null,0]
[null,"2024-02-17","Samstag",null,0]
[null,"2024-02-18","Sonntag",null,0]
[null,"2024-02-19","Montag",8,0]
[null,"2024-02-20","Dienstag",null,0]
[null,"2024-02-21","Mittwoch",null,0]
[null,"2024-02-22","Donnerstag",null,0]
[null,"2024-02-23","Freitag",null,0]
[null,"2024-02-24","Samstag",null,0]
[null,"2024-02-25","Sonntag",null,0]
[null,"2024-02-26","Montag",9,0]
[null,"2024-02-27","Dienstag",null,0]
[null,"2024-02-28","Mittwoch",null,0]
[null,"2024-02-29","Donnerstag",null,0]
[null,"2024-03-01","Freitag",null,0]
[null,"2024-03-02","Samstag",null,0]
[null,"2024-03-03","Sonntag",null,0]
[null,"2024-03-04","Montag",10,0]
[null,"2024-03-05","Dienstag",null,{"$f":"COUNTIF(G76:KF76,\"*\")","v":0}]
[null,"2024-03-06",{"$f":"IF(WEEKDAY(B77)=1,\"Sonntag\",IF(WEEKDAY(B77)=2,\"Montag\",IF(WEEKDAY(B77)=3,\"Dienstag\",IF(WEEKDAY(B77)=4,\"Mittwoch\",IF(WEEKDAY(B77)=5,\"Donnerstag\",IF(WEEKDAY(B77)=6,\"Freitag\",\"Samstag\"))))))","v":"Mittwoch"},null,0]
[null,"2024-03-07","Donnerstag",null,0]
[null,"2024-03-08","Freitag",null,0]
[null,"2024-03-09","Samstag",null,0]
[null,"2024-03-10","Sonntag",null,0]
[null,"2024-03-11","Montag",11,0]
[null,"2024-03-12","Dienstag",null,0]
[null,"2024-03-13","Mittwoch",null,0]
[null,"2024-03-14","Donnerstag",null,0]
[null,{"$f":"B85+1","v":"2024-03-15"},"Freitag",null,0]
[null,"2024-03-16","Samstag",null,0]
[null,"2024-03-17","Sonntag",null,0]
[null,"2024-03-18","Montag",12,0]
[null,"2024-03-19","Dienstag",null,0]
[null,"2024-03-20","Mittwoch",null,0]
[null,"2024-03-21","Donnerstag",null,0]
[null,"2024-03-22","Freitag",null,0]
[null,"2024-03-23","Samstag",null,0]
[null,"2024-03-24","Sonntag",null,0]
[null,"2024-03-25","Montag",13,0]
[null,"2024-03-26","Dienstag",null,0]
[null,"2024-03-27","Mittwoch",null,{"$f":"COUNTIF(G98:KF98,\"*\")","v":0}]
[null,"2024-03-28","Donnerstag",null,0]
[null,"2024-03-29","Freitag",null,0]
[null,"2024-03-30","Samstag",null,0]
[null,"2024-03-31","Sonntag",null,0]
[null,"2024-04-01","Montag",14,0]
[null,"2024-04-02","Dienstag",null,0]
[null,"2024-04-03","Mittwoch",null,0]
[null,"2024-04-04","Donnerstag",null,0]
[null,"2024-04-05","Freitag",null,0]
[null,"2024-04-06","Samstag",null,0]
[null,"2024-04-07","Sonntag",null,0]
[null,"2024-04-08","Montag",15,0]
[null,"2024-04-09","Dienstag",null,0]
[null,"2024-04-10","Mittwoch",null,0]
[null,"2024-04-11","Donnerstag",null,0]
[null,"2024-04-12","Freitag",null,0]
[null,"2024-04-13","Samstag",null,0]
[null,"2024-04-14","Sonntag",null,0]
[null,"2024-04-15","Montag",16,0]
[null,"2024-04-16","Dienstag",null,0]
[null,"2024-04-17","Mittwoch",null,0]
[null,"2024-04-18","Donnerstag",null,0]
[null,"2024-04-19","Freitag",null,0]
[null,"2024-04-20","Samstag",null,0]
[null,"2024-04-21","Sonntag",null,0]
[null,"2024-04-22","Montag",17,0]
[null,"2024-04-23","Dienstag",null,0]
[null,"2024-04-24","Mittwoch",null,0]
[null,"2024-04-25","Donnerstag",null,0]
[null,"2024-04-26","Freitag",null,0]
[null,"2024-04-27","Samstag",null,0]
[null,"2024-04-28","Sonntag",null,0]
[null,"2024-04-29","Montag",18,0]
[null,"2024-04-30","Dienstag",null,0]
[null,"2024-05-01","Mittwoch",null,0]
[null,"2024-05-02","Donnerstag",null,0]
[null,"2024-05-03","Freitag",null,0]
[null,"2024-05-04","Samstag",null,0]
[null,"2024-05-05","Sonntag",null,0]
[null,"2024-05-06","Montag",19,0]
[null,"2024-05-07","Dienstag",null,0]
[null,"2024-05-08","Mittwoch",null,{"$f":"COUNTIF(G140:KF140,\"*\")","v":0}]
[null,"2024-05-09",{"$f":"IF(WEEKDAY(B141)=1,\"Sonntag\",IF(WEEKDAY(B141)=2,\"Montag\",IF(WEEKDAY(B141)=3,\"Dienstag\",IF(WEEKDAY(B141)=4,\"Mittwoch\",IF(WEEKDAY(B141)=5,\"Donnerstag\",IF(WEEKDAY(B141)=6,\"Freitag\",\"Samstag\"))))))","v":"Donnerstag"},null,0]
[null,"2024-05-10","Freitag",null,0]
[null,"2024-05-11","Samstag",null,0]
[null,"2024-05-12","Sonntag",null,0]
[null,"2024-05-13","Montag",20,0]
[null,"2024-05-14","Dienstag",null,0]
[null,"2024-05-15","Mittwoch",null,0]
[null,"2024-05-16","Donnerstag",null,0]
[null,"2024-05-17","Freitag",null,0]
[null,{"$f":"B149+1","v":"2024-05-18"},"Samstag",null,0]
[null,"2024-05-19","Sonntag",null,0]
[null,"2024-05-20","Montag",21,0]
[null,"2024-05-21","Dienstag",null,0]
[null,"2024-05-22","Mittwoch",null,0]
[null,"2024-05-23","Donnerstag",null,0]
[null,"2024-05-24","Freitag",null,0]
[null,"2024-05-25","Samstag",null,0]
[null,"2024-05-26","Sonntag",null,0]
[null,"2024-05-27","Montag",22,0]
[null,"2024-05-28","Dienstag",null,0]
[null,"2024-05-29","Mittwoch",null,0]
[null,"2024-05-30","Donnerstag",null,0]
[null,"2024-05-31","Freitag",null,0]
[null,"2024-06-01","Samstag",null,0]
[null,"2024-06-02","Sonntag",null,0]
[null,"2024-06-03","Montag",23,0]
[null,"2024-06-04","Dienstag",null,0]
[null,"2024-06-05","Mittwoch",null,0]
[null,"2024-06-06","Donnerstag",null,0]
[null,"2024-06-07","Freitag",null,0]
[null,"2024-06-08","Samstag",null,0]
[null,"2024-06-09","Sonntag",null,0]
[null,"2024-06-10","Montag",24,0]
[null,"2024-06-11","Dienstag",null,0]
[null,"2024-06-12","Mittwoch",null,0]
[null,"2024-06-13","Donnerstag",null,0]
[null,"2024-06-14","Freitag",null,0]
[null,"2024-06-15","Samstag",null,0]
[null,"2024-06-16","Sonntag",null,0]
[null,"2024-06-17","Montag",25,0]
[null,"2024-06-18","Dienstag",null,0]
[null,"2024-06-19","Mittwoch",null,0]
[null,"2024-06-20","Donnerstag",null,0]
[null,"2024-06-21","Freitag",null,0]
[null,"2024-06-22","Samstag",null,0]
[null,"2024-06-23","Sonntag",null,0]
[null,"2024-06-24","Montag",26,0]
[null,"2024-06-25","Dienstag",null,0]
[null,"2024-06-26","Mittwoch",null,0]
[null,"2024-06-27","Donnerstag",null,0]
[null,"2024-06-28","Freitag",null,0]
[null,"2024-06-29","Samstag",null,0]
[null,"2024-06-30","Sonntag",null,0]
[null,"2024-07-01","Montag",27,0]
[null,"2024-07-02","Dienstag",null,0]
[null,"2024-07-03","Mittwoch",null,0]
[null,"2024-07-04","Donnerstag",null,0]
[null,"2024-07-05","Freitag",null,0]
[null,"2024-07-06","Samstag",null,0]
[null,"2024-07-07","Sonntag",null,0]
[null,"2024-07-08","Montag",28,0]
[null,"2024-07-09","Dienstag",null,0]
[null,"2024-07-10","Mittwoch",null,0]
[null,"2024-07-11","Donnerstag",null,{"$f":"COUNTIF(G204:KF204,\"*\")","v":0}]
[null,"2024-07-12",{"$f":"IF(WEEKDAY(B205)=1,\"Sonntag\",IF(WEEKDAY(B205)=2,\"Montag\",IF(WEEKDAY(B205)=3,\"Dienstag\",IF(WEEKDAY(B205)=4,\"Mittwoch\",IF(WEEKDAY(B205)=5,\"Donnerstag\",IF(WEEKDAY(B205)=6,\"Freitag\",\"Samstag\"))))))","v":"Freitag"},null,0]
[null,"2024-07-13","Samstag",null,0]
[null,"2024-07-14","Sonntag",null,0]
[null,"2024-07-15","Montag",29,0]
[null,"2024-07-16","Dienstag",null,0]
[null,"2024-07-17","Mittwoch",null,0]
[null,"2024-07-18","Donnerstag",null,0]
[null,"2024-07-19","Freitag",null,0]
[null,"2024-07-20","Samstag",null,0]
[null,{"$f":"B213+1","v":"2024-07-21"},"Sonntag",null,0]
[null,"2024-07-22","Montag",30,0]
[null,"2024-07-23","Dienstag",null,0]
[null,"2024-07-24","Mittwoch",null,0]
[null,"2024-07-25","Donnerstag",null,0]
[null,"2024-07-26","Freitag",null,0]
[null,"2024-07-27","Samstag",null,0]
[null,"2024-07-28","Sonntag",null,0]
[null,"2024-07-29","Montag",31,0]
[null,"2024-07-30","Dienstag",null,0]
[null,"2024-07-31","Mittwoch",null,0]
[null,"2024-08-01","Donnerstag",null,0]
[null,"2024-08-02","Freitag",null,0]
[null,"2024-08-03","Samstag",null,0]
[null,"2024-08-04","Sonntag",null,0]
[null,"2024-08-05","Montag",32,0]
[null,"2024-08-06","Dienstag",null,0]
[null,"2024-08-07","Mittwoch",null,0]
[null,"2024-08-08","Donnerstag",null,0]
[null,"2024-08-09","Freitag",null,0]
[null,"2024-08-10","Samstag",null,0]
[null,"2024-08-11","Sonntag",null,0]
[null,"2024-08-12","Montag",33,0]
[null,"2024-08-13","Dienstag",null,0]
[null,"2024-08-14","Mittwoch",null,0]
[null,"2024-08-15","Donnerstag",null,0]
[null,"2024-08-16","Freitag",null,0]
[null,"2024-08-17","Samstag",null,0]
[null,"2024-08-18","Sonntag",null,0]
[null,"2024-08-19","Montag",34,0]
[null,"2024-08-20","Dienstag",null,0]
[null,"2024-08-21","Mittwoch",null,0]
[null,"2024-08-22","Donnerstag",null,0]
[null,"2024-08-23","Freitag",null,0]
[null,"2024-08-24","Samstag",null,0]
[null,"2024-08-25","Sonntag",null,0]
[null,"2024-08-26","Montag",35,0]
[null,"2024-08-27","Dienstag",null,0]
[null,"2024-08-28","Mittwoch",null,0]
[null,"2024-08-29","Donnerstag",null,0]
[null,"2024-08-30","Freitag",null,0]
[null,"2024-08-31","Samstag",null,0]
[null,"2024-09-01","Sonntag",null,0]
[null,"2024-09-02","Montag",36,0]
[null,"2024-09-03","Dienstag",null,0]
[null,"2024-09-04","Mittwoch",null,0]
[null,"2024-09-05","Donnerstag",null,0]
[null,"2024-09-06","Freitag",null,0]
[null,"2024-09-07","Samstag",null,0]
[null,"2024-09-08","Sonntag",null,0]
[null,"2024-09-09","Montag",37,0]
[null,"2024-09-10","Dienstag",null,0]
[null,"2024-09-11","Mittwoch",null,0]
[null,"2024-09-12","Donnerstag",null,0]
[null,"2024-09-13","Freitag",null,{"$f":"COUNTIF(G268:KF268,\"*\")","v":0}]
[null,"2024-09-14",{"$f":"IF(WEEKDAY(B269)=1,\"Sonntag\",IF(WEEKDAY(B269)=2,\"Montag\",IF(WEEKDAY(B269)=3,\"Dienstag\",IF(WEEKDAY(B269)=4,\"Mittwoch\",IF(WEEKDAY(B269)=5,\"Donnerstag\",IF(WEEKDAY(B269)=6,\"Freitag\",\"Samstag\"))))))","v":"Samstag"},null,0]
[null,"2024-09-15","Sonntag",null,0]
[null,"2024-09-16","Montag",38,0]
[null,"2024-09-17","Dienstag",null,0]
[null,"2024-09-18","Mittwoch",null,0]
[null,"2024-09-19","Donnerstag",null,0]
[null,"2024-09-20","Freitag",null,0]
[null,"2024-09-21","Samstag",null,0]
[null,"2024-09-22","Sonntag",null,0]
[null,{"$f":"B277+1","v":"2024-09-23"},"Montag",39,0]
[null,"2024-09-24","Dienstag",null,0]
[null,"2024-09-25","Mittwoch",null,0]
[null,"2024-09-26","Donnerstag",null,0]
[null,"2024-09-27","Freitag",null,0]
[null,"2024-09-28","Samstag",null,0]
[null,"2024-09-29","Sonntag",null,0]
[null,"2024-09-30","Montag",40,0]
[null,"2024-10-01","Dienstag",null,0]
[null,"2024-10-02","Mittwoch",null,0]
[null,"2024-10-03","Donnerstag",null,0]
[null,"2024-10-04","Freitag",null,0]
[null,"2024-10-05","Samstag",null,0]
[null,"2024-10-06","Sonntag",null,0]
[null,"2024-10-07","Montag",41,0]
[null,"2024-10-08","Dienstag",null,0]
[null,"2024-10-09","Mittwoch",null,0]
[null,"2024-10-10","Donnerstag",null,0]
[null,"2024-10-11","Freitag",null,0]
[null,"2024-10-12","Samstag",null,0]
[null,"2024-10-13","Sonntag",null,0]
[null,"2024-10-14","Montag",42,0]
[null,"2024-10-15","Dienstag",null,0]
[null,"2024-10-16","Mittwoch",null,0]
[null,"2024-10-17","Donnerstag",null,0]
[null,"2024-10-18","Freitag",null,0]
[null,"2024-10-19","Samstag",null,0]
[null,"2024-10-20","Sonntag",null,0]
[null,"2024-10-21","Montag",43,0]
[null,"2024-10-22","Dienstag",null,0]
[null,"2024-10-23","Mittwoch",null,0]
[null,"2024-10-24","Donnerstag",null,0]
[null,"2024-10-25","Freitag",null,0]
[null,"2024-10-26","Samstag",null,0]
[null,"2024-10-27","Sonntag",null,0]
[null,"2024-10-28","Montag",44,0]
[null,"2024-10-29","Dienstag",null,0]
[null,"2024-10-30","Mittwoch",null,0]
[null,"2024-10-31","Donnerstag",null,0]
[null,"2024-11-01","Freitag",null,0]
[null,"2024-11-02","Samstag",null,0]
[null,"2024-11-03","Sonntag",null,0]
[null,"2024-11-04","Montag",45,0]
[null,"2024-11-05","Dienstag",null,0]
[null,"2024-11-06","Mittwoch",null,0]
[null,"2024-11-07","Donnerstag",null,0]
[null,"2024-11-08","Freitag",null,0]
[null,"2024-11-09","Samstag",null,0]
[null,"2024-11-10","Sonntag",null,0]
[null,"2024-11-11","Montag",46,0]
[null,"2024-11-12","Dienstag",null,0]
[null,"2024-11-13","Mittwoch",null,0]
[null,"2024-11-14","Donnerstag",null,0]
[null,"2024-11-15","Freitag",null,0]
[null,"2024-11-16","Samstag",null,{"$f":"COUNTIF(G332:KF332,\"*\")","v":0}]
[null,"2024-11-17",{"$f":"IF(WEEKDAY(B333)=1,\"Sonntag\",IF(WEEKDAY(B333)=2,\"Montag\",IF(WEEKDAY(B333)=3,\"Dienstag\",IF(WEEKDAY(B333)=4,\"Mittwoch\",IF(WEEKDAY(B333)=5,\"Donnerstag\",IF(WEEKDAY(B333)=6,\"Freitag\",\"Samstag\"))))))","v":"Sonntag"},null,0]
[null,"2024-11-18","Montag",47,0]
[null,"2024-11-19","Dienstag",null,0]
[null,"2024-11-20","Mittwoch",null,0]
[null,"2024-11-21","Donnerstag",null,0]
[null,"2024-11-22","Freitag",null,0]
[null,"2024-11-23","Samstag",null,0]
[null,"2024-11-24","Sonntag",null,0]
[null,"2024-11-25","Montag",48,0]
[null,{"$f":"B341+1","v":"2024-11-26"},"Dienstag",null,0]
[null,"2024-11-27","Mittwoch",null,0]
[null,"2024-11-28","Donnerstag",null,0]
[null,"2024-11-29","Freitag",null,0]
[null,"2024-11-30","Samstag",null,0]
[null,"2024-12-01","Sonntag",null,0]
[null,"2024-12-02","Montag",49,0]
[null,"2024-12-03","Dienstag",null,0]
[null,"2024-12-04","Mittwoch",null,0]
[null,"2024-12-05","Donnerstag",null,0]
[null,"2024-12-06","Freitag",null,0]
[null,"2024-12-07","Samstag",null,0]
[null,"2024-12-08","Sonntag",null,0]
[null,"2024-12-09","Montag",50,0]
[null,"2024-12-10","Dienstag",null,0]
[null,"2024-12-11","Mittwoch",null,0]
[null,"2024-12-12","Donnerstag",null,0]
[null,"2024-12-13","Freitag",null,0]
[null,"2024-12-14","Samstag",null,0]
[null,"2024-12-15","Sonntag",null,0]
[null,"2024-12-16","Montag",51,0]
[null,"2024-12-17","Dienstag",null,0]
[null,"2024-12-18","Mittwoch",null,0]
[null,"2024-12-19","Donnerstag",null,0]
[null,"2024-12-20","Freitag",null,0]
[null,"2024-12-21","Samstag",null,0]
[null,"2024-12-22","Sonntag",null,0]
[null,"2024-12-23","Montag",52,0]
[null,"2024-12-24","Dienstag",null,0]
[null,"2024-12-25","Mittwoch",null,0]
[null,"2024-12-26","Donnerstag",null,0]
[null,"2024-12-27","Freitag",null,0]
[null,"2024-12-28","Samstag",null,0]
[null,{"$f":"B374+1","v":"2024-12-29"},"Sonntag",null,0]
[null,"2024-12-30","Montag",1,0]
[null,"2024-12-31","Dienstag",null,0]
[null,"2025-01-01","Mittwoch",null,0]
[null,"2025-01-02","Donnerstag",null,0]
[null,"2025-01-03","Freitag",null,0]
[null,"2025-01-04","Samstag",null,0]
[null,{"$f":"B381+1","v":"2025-01-05"},"Sonntag",null,0]
[null,{"$f":"B382+1","v":"2025-01-06"},"Montag",null,0]
[null,{"$f":"B383+1","v":"2025-01-07"},"Dienstag",null,0]
[null,{"$f":"B384+1","v":"2025-01-08"},"Mittwoch",null,0]
[null,{"$f":"B385+1","v":"2025-01-09"},"Donnerstag",null,0]

{"sheet":"Urlaubsantrag","index":2,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,1,30,9],[32,1,32,6],[7,8,7,9],[8,8,8,9],[7,1,7,6],[8,1,8,6],[25,1,25,9],[12,6,13,9],[26,1,26,9],[23,1,23,4],[29,4,29,6],[24,1,24,4],[24,6,24,9],[15,6,16,9],[16,1,16,4],[17,1,17,4],[1,1,1,9],[21,6,23,9],[11,1,11,4],[11,6,11,9],[10,1,10,4],[5,1,5,9],[10,6,10,9],[4,4,4,6],[13,1,13,4],[14,1,14,4],[14,6,14,9],[19,7,19,8],[20,7,20,8],[17,6,17,9],[35,1,35,4],[35,6,35,9],[36,1,36,4],[33,1,33,6],[32,8,32,9],[36,6,36,9],[33,8,33,9],[45,7,45,8],[49,1,49,4],[49,6,49,9],[46,6,48,9],[38,1,38,4],[37,6,38,9],[39,1,39,4],[48,1,48,4],[44,7,44,8],[39,6,39,9],[40,6,41,9],[41,1,41,4],[42,1,42,4],[42,6,42,9]]}
[]
[null,"Urlaubsantrag (Ausfertigung für die Firma)"]
[]
[]
[null,"x"," Urlaub",null," Frei- / Gleitzeitausgleich",null,null,null," Weiterbildung / Seminar"]
[]
[]
[null,"Beispiel, Tanja",null,null,null,null,null,null,10]
[null,"Name",null,null,null,null,null,null,"Anzahl der Fehltage"]
[]
[null,"06.01.2024",null,null,null,null,"21.01.2024"]
[null,"Von",null,null,null,null,"Bis"]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Mitarbeiter(in)"]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Urlaubsvertreter(in)"]
[]
[null,null,null,null,null,null,"Url.-Anspruch","Ist-Urlaub",null,"Resturlaub"]
[null,null," Genehmigt",null," Abgelehnt",null,40,10,null,{"$f":"G21-H21","v":30}]
[]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Sachbearbeiter(in)"]
[]
[null,"Urlaubsantrag (Ausfertigung für den / die Mitarbeiter(in))"]
[]
[]
[null,{"$f":"IF(B5=\"\",\"\",B5)","v":"x"}," Urlaub",{"$f":"IF(D5=\"\",\"\",D5)","v":""}," Frei- / Gleitzeitausgleich",null,null,{"$f":"IF(H5=\"\",\"\",H5)","v":""}," Weiterbildung / Seminar"]
[]
[]
[null,{"$f":"IF(B8=\"\",\"\",B8)","v":"Beispiel, Tanja"},null,null,null,null,null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":10}]
[null,"Name",null,null,null,null,null,null,"Anzahl der Fehltage"]
[]
[null,{"$f":"IF(B11=\"\",\"\",B11)","v":"06.01.2024"},null,null,null,null,{"$f":"IF(G11=\"\",\"\",G11)","v":"21.01.2024"}]
[null,"Von",null,null,null,null,"Bis"]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Mitarbeiter(in)"]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Urlaubsvetreter(in)"]
[]
[null,null,null,null,null,null,"Url.-Anspruch","Ist-Urlaub",null,"Resturlaub"]
[null,{"$f":"IF(B21=\"\",\"\",B21)","v":""}," Genehmigt",{"$f":"IF(D21=\"\",\"\",D21)","v":""}," Abgelehnt",null,{"$f":"IF(G21=\"\",\"\",G21)","v":40},{"$f":"IF(H21=\"\",\"\",H21)","v":10},{"$f":"IF(I21=\"\",\"\",I21)","v":""},{"$f":"IF(J21=\"\",\"\",J21)","v":30}]
[]
[]
[null,{"$f":"TODAY()","v":"2023-11-02"}]
[null,"Datum",null,null,null,null,"Unterschrift Sachbearbeiter(in)"]

{"sheet":"AbteilungMonat","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,12],[39,3,39,12],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2]]}
[]
[null,{"$f":"\"Monat:  \"&MONTH(B4)&\" / \"&YEAR(B4)","v":"Monat:  1 / 2024"}]
[null,"Einkauf","Anzahl fehlender MA","Beispiel, Sven","Beispiel, Tanja"]
[null,"2024-01-01",{"$f":"COUNTIF(D4:AL4,\"*\")","v":0}]
[null,"2024-01-02",{"$f":"COUNTIF(D5:AL5,\"*\")","v":0}]
[null,"2024-01-03",0]
[null,"2024-01-04",0]
[null,"2024-01-05",0]
[null,"2024-01-06",0]
[null,"2024-01-07",0]
[null,"2024-01-08",1,null,"U"]
[null,"2024-01-09",1,null,"U"]
[null,"2024-01-10",1,null,"U"]
[null,"2024-01-11",1,null,"U"]
[null,"2024-01-12",1,null,"U"]
[null,"2024-01-13",0]
[null,"2024-01-14",0]
[null,"2024-01-15",2,"U","U"]
[null,"2024-01-16",2,"U","U"]
[null,"2024-01-17",2,"U","U"]
[null,"2024-01-18",2,"U","U"]
[null,"2024-01-19",2,"U","U"]
[null,"2024-01-20",0]
[null,"2024-01-21",0]
[null,"2024-01-22",1,"U"]
[null,"2024-01-23",1,"U"]
[null,"2024-01-24",1,"U"]
[null,"2024-01-25",1,"U"]
[null,"2024-01-26",1,"U"]
[null,"2024-01-27",0]
[null,"2024-01-28",0]
[null,"2024-01-29",0]
[null,"2024-01-30",0]
[null,"2024-01-31",0]
[null,"Urlaub",null,{"$f":"COUNTIF(D$4:D$34,\"U\")+COUNTIF(D$4:D$34,\"U½\")/2","v":10},10,0,0,0,0,0,0,0,0]
[null,"Frei-/Gleitzeitausgl.",null,{"$f":"COUNTIF(D$4:D$34,\"F\")+COUNTIF(D$4:D$34,\"F½\")/2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Weiterbildung",null,{"$f":"COUNTIF(D$4:D$34,\"W\")+COUNTIF(D$4:D$34,\"W½\")/2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Krank",null,{"$f":"COUNTIF(D$4:D$34,\"K\")+COUNTIF(D$4:D$34,\"K½\")/2","v":0},0,0,0,0,0,0,0,0,0]
[null,"Gesamt/MA",null,{"$f":"SUM(D35:D38)","v":10},10,0,0,0,0,0,0,0,0]
[null,"Gesamt/Abteilung",null,{"$f":"SUM(D39:M39)","v":20}]

{"sheet":"Ferientage","index":4,"n_rows":103,"n_cols":17,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,1,1,16]]}
[]
[null,"Schulferien aktuelles Jahr - Ohne Gewähr!"]
[null,"BW","BY","BE","BB","HB","HH","HE","MV","NI","NRW","RP","SL","SN","ST","SH","TH"]
[null,"2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01","2024-01-01"]
[null,"2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02","2024-01-02"]
[null,"2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-01-03","2024-02-12","2024-02-12","2024-01-03","2024-01-03","2024-01-03"]
[null,"2024-01-04","2024-01-04","2024-01-04","2024-01-04","2024-01-04","2024-01-04","2024-01-04","2024-02-05","2024-01-04","2024-01-04","2024-01-04","2024-02-13","2024-02-13","2024-02-05","2024-01-04","2024-01-04"]
[null,"2024-01-05","2024-01-05","2024-01-05","2024-01-05","2024-01-05","2024-01-05","2024-01-05","2024-02-06","2024-01-05","2024-01-05","2024-01-05","2024-02-14","2024-02-14","2024-02-06","2024-01-05","2024-01-05"]
[null,"2024-03-23","2024-02-12","2024-02-05","2024-02-05","2024-02-01","2024-02-02","2024-01-06","2024-02-07","2024-02-01","2024-03-25","2024-03-25","2024-02-15","2024-02-15","2024-02-07","2024-01-06","2024-02-12"]
[null,"2024-03-24","2024-02-13","2024-02-06","2024-02-06","2024-02-02","2024-03-18","2024-01-07","2024-02-08","2024-02-02","2024-03-26","2024-03-26","2024-02-16","2024-02-16","2024-02-08","2024-04-02","2024-02-13"]
[null,"2024-03-25","2024-02-14","2024-02-07","2024-02-07","2024-03-18","2024-03-19","2024-01-08","2024-02-09","2024-03-18","2024-03-27","2024-03-27","2024-03-25","2024-02-17","2024-02-09","2024-04-03","2024-02-14"]
[null,"2024-03-26","2024-02-15","2024-02-08","2024-02-08","2024-03-19","2024-03-20","2024-01-09","2024-02-10","2024-03-19","2024-03-28","2024-03-28","2024-03-26","2024-02-18","2024-02-10","2024-04-04","2024-02-15"]
[null,"2024-03-27","2024-02-16","2024-02-09","2024-02-09","2024-03-20","2024-03-21","2024-01-10","2024-02-11","2024-03-20","2024-03-29","2024-03-29","2024-03-27","2024-02-19","2024-03-25","2024-04-05","2024-02-16"]
[null,"2024-03-28","2024-03-25","2024-02-10","2024-03-25","2024-03-21","2024-03-22","2024-01-11","2024-02-12","2024-03-21","2024-03-30","2024-03-30","2024-03-28","2024-02-20","2024-03-26","2024-04-06","2024-03-25"]
[null,"2024-03-29","2024-03-26","2024-03-25","2024-03-26","2024-03-22","2024-03-23","2024-01-12","2024-02-13","2024-03-22","2024-03-31","2024-03-31","2024-03-29","2024-02-21","2024-03-27","2024-04-07","2024-03-26"]
[null,"2024-03-30","2024-03-27","2024-03-26","2024-03-27","2024-03-23","2024-03-24","2024-01-13","2024-02-14","2024-03-23","2024-04-01","2024-04-01","2024-03-30","2024-02-22","2024-03-28","2024-04-08","2024-03-27"]
[null,"2024-03-31","2024-03-28","2024-03-27","2024-03-28","2024-03-24","2024-03-25","2024-03-25","2024-02-15","2024-03-24","2024-04-02","2024-04-02","2024-03-31","2024-02-23","2024-03-29","2024-04-09","2024-03-28"]
[null,"2024-04-01","2024-03-29","2024-03-28","2024-03-29","2024-03-25","2024-03-26","2024-03-26","2024-02-16","2024-03-25","2024-04-03","2024-05-21","2024-04-01","2024-03-28","2024-03-30","2024-04-10","2024-03-29"]
[null,"2024-04-02","2024-03-30","2024-03-29","2024-03-30","2024-03-26","2024-03-27","2024-03-27","2024-03-25","2024-03-26","2024-04-04","2024-05-22","2024-04-02","2024-03-29","2024-05-21","2024-04-11","2024-03-30"]
[null,"2024-04-03","2024-03-31","2024-03-30","2024-03-31","2024-03-27","2024-03-28","2024-03-28","2024-03-26","2024-03-27","2024-04-05","2024-05-23","2024-04-03","2024-03-30","2024-05-22","2024-04-12","2024-03-31"]
[null,"2024-04-04","2024-04-01","2024-03-31","2024-04-01","2024-03-28","2024-05-10","2024-03-29","2024-03-27","2024-03-28","2024-04-06","2024-05-24","2024-04-04","2024-03-31","2024-05-23","2024-04-13","2024-04-01"]
[null,"2024-04-05","2024-04-02","2024-04-01","2024-04-02","2024-05-10","2024-05-21","2024-03-30","2024-03-28","2024-05-10","2024-05-21","2024-05-25","2024-04-05","2024-04-01","2024-05-24","2024-04-14","2024-04-02"]
[null,"2024-05-21","2024-04-03","2024-04-02","2024-04-03","2024-05-21","2024-05-22","2024-03-31","2024-03-29","2024-05-21","2024-07-08","2024-05-26","2024-05-21","2024-04-02","2024-06-24","2024-04-15","2024-04-03"]
[null,"2024-05-22","2024-04-04","2024-04-03","2024-04-04","2024-06-24","2024-05-23","2024-04-01","2024-03-30","2024-06-24","2024-07-09","2024-05-27","2024-05-22","2024-04-03","2024-06-25","2024-04-16","2024-04-04"]
[null,"2024-05-23","2024-04-05","2024-04-04","2024-04-05","2024-06-25","2024-05-24","2024-04-02","2024-03-31","2024-06-25","2024-07-10","2024-05-28","2024-05-23","2024-04-04","2024-06-26","2024-04-17","2024-04-05"]
[null,"2024-05-24","2024-04-06","2024-04-05","2024-07-18","2024-06-26","2024-07-18","2024-04-03","2024-04-01","2024-06-26","2024-07-11","2024-05-29","2024-05-24","2024-04-05","2024-06-27","2024-04-18","2024-04-06"]
[null,"2024-05-25","2024-05-21","2024-05-10","2024-07-19","2024-06-27","2024-07-19","2024-04-04","2024-04-02","2024-06-27","2024-07-12","2024-07-15","2024-07-15","2024-05-10","2024-06-28","2024-04-19","2024-05-10"]
[null,"2024-05-26","2024-05-22","2024-07-18","2024-07-20","2024-06-28","2024-07-20","2024-04-05","2024-04-03","2024-06-28","2024-07-13","2024-07-16","2024-07-16","2024-05-18","2024-06-29","2024-05-10","2024-06-20"]
[null,"2024-05-27","2024-05-23","2024-07-19","2024-07-21","2024-06-29","2024-07-21","2024-04-06","2024-05-10","2024-06-29","2024-07-14","2024-07-17","2024-07-17","2024-05-19","2024-06-30","2024-05-11","2024-06-21"]
[null,"2024-05-28","2024-05-24","2024-07-20","2024-07-22","2024-06-30","2024-07-22","2024-04-07","2024-05-17","2024-06-30","2024-07-15","2024-07-18","2024-07-18","2024-05-20","2024-07-01","2024-07-22","2024-06-22"]
[null,"2024-05-29","2024-05-25","2024-07-21","2024-07-23","2024-07-01","2024-07-23","2024-04-08","2024-05-18","2024-07-01","2024-07-16","2024-07-19","2024-07-19","2024-05-21","2024-07-02","2024-07-23","2024-06-23"]
[null,"2024-05-30","2024-05-26","2024-07-22","2024-07-24","2024-07-02","2024-07-24","2024-04-09","2024-05-19","2024-07-02","2024-07-17","2024-07-20","2024-07-20","2024-06-20","2024-07-03","2024-07-24","2024-06-24"]
[null,"2024-05-31","2024-05-27","2024-07-23","2024-07-25","2024-07-03","2024-07-25","2024-04-10","2024-05-20","2024-07-03","2024-07-18","2024-07-21","2024-07-21","2024-06-21","2024-07-04","2024-07-25","2024-06-25"]
[null,"2024-07-25","2024-05-28","2024-07-24","2024-07-26","2024-07-04","2024-07-26","2024-04-11","2024-05-21","2024-07-04","2024-07-19","2024-07-22","2024-07-22","2024-06-22","2024-07-05","2024-07-26","2024-06-26"]
[null,"2024-07-26","2024-05-29","2024-07-25","2024-07-27","2024-07-05","2024-07-27","2024-04-12","2024-07-22","2024-07-05","2024-07-20","2024-07-23","2024-07-23","2024-06-23","2024-07-06","2024-07-27","2024-06-27"]
[null,"2024-07-27","2024-05-30","2024-07-26","2024-07-28","2024-07-06","2024-07-28","2024-04-13","2024-07-23","2024-07-06","2024-07-21","2024-07-24","2024-07-24","2024-06-24","2024-07-07","2024-07-28","2024-06-28"]
[null,"2024-07-28","2024-05-31","2024-07-27","2024-07-29","2024-07-07","2024-07-29","2024-07-15","2024-07-24","2024-07-07","2024-07-22","2024-07-25","2024-07-25","2024-06-25","2024-07-08","2024-07-29","2024-06-29"]
[null,"2024-07-29","2024-06-01","2024-07-28","2024-07-30","2024-07-08","2024-07-30","2024-07-16","2024-07-25","2024-07-08","2024-07-23","2024-07-26","2024-07-26","2024-06-26","2024-07-09","2024-07-30","2024-06-30"]
[null,"2024-07-30","2024-07-29","2024-07-29","2024-07-31","2024-07-09","2024-07-31","2024-07-17","2024-07-26","2024-07-09","2024-07-24","2024-07-27","2024-07-27","2024-06-27","2024-07-10","2024-07-31","2024-07-01"]
[null,"2024-07-31","2024-07-30","2024-07-30","2024-08-01","2024-07-10","2024-08-01","2024-07-18","2024-07-27","2024-07-10","2024-07-25","2024-07-28","2024-07-28","2024-06-28","2024-07-11","2024-08-01","2024-07-02"]
[null,"2024-08-01","2024-07-31","2024-07-31","2024-08-02","2024-07-11","2024-08-02","2024-07-19","2024-07-28","2024-07-11","2024-07-26","2024-07-29","2024-07-29","2024-06-29","2024-07-12","2024-08-02","2024-07-03"]
[null,"2024-08-02","2024-08-01","2024-08-01","2024-08-03","2024-07-12","2024-08-03","2024-07-20","2024-07-29","2024-07-12","2024-07-27","2024-07-30","2024-07-30","2024-06-30","2024-07-13","2024-08-03","2024-07-04"]
[null,"2024-08-03","2024-08-02","2024-08-02","2024-08-04","2024-07-13","2024-08-04","2024-07-21","2024-07-30","2024-07-13","2024-07-28","2024-07-31","2024-07-31","2024-07-01","2024-07-14","2024-08-04","2024-07-05"]
[null,"2024-08-04","2024-08-03","2024-08-03","2024-08-05","2024-07-14","2024-08-05","2024-07-22","2024-07-31","2024-07-14","2024-07-29","2024-08-01","2024-08-01","2024-07-02","2024-07-15","2024-08-05","2024-07-06"]
[null,"2024-08-05","2024-08-04","2024-08-04","2024-08-06","2024-07-15","2024-08-06","2024-07-23","2024-08-01","2024-07-15","2024-07-30","2024-08-02","2024-08-02","2024-07-03","2024-07-16","2024-08-06","2024-07-07"]
[null,"2024-08-06","2024-08-05","2024-08-05","2024-08-07","2024-07-16","2024-08-07","2024-07-24","2024-08-02","2024-07-16","2024-07-31","2024-08-03","2024-08-03","2024-07-04","2024-07-17","2024-08-07","2024-07-08"]
[null,"2024-08-07","2024-08-06","2024-08-06","2024-08-08","2024-07-17","2024-08-08","2024-07-25","2024-08-03","2024-07-17","2024-08-01","2024-08-04","2024-08-04","2024-07-05","2024-07-18","2024-08-08","2024-07-09"]
[null,"2024-08-08","2024-08-07","2024-08-07","2024-08-09","2024-07-18","2024-08-09","2024-07-26","2024-08-04","2024-07-18","2024-08-02","2024-08-05","2024-08-05","2024-07-06","2024-07-19","2024-08-09","2024-07-10"]
[null,"2024-08-09","2024-08-08","2024-08-08","2024-08-10","2024-07-19","2024-08-10","2024-07-27","2024-08-05","2024-07-19","2024-08-03","2024-08-06","2024-08-06","2024-07-07","2024-07-20","2024-08-10","2024-07-11"]
[null,"2024-08-10","2024-08-09","2024-08-09","2024-08-11","2024-07-20","2024-08-11","2024-07-28","2024-08-06","2024-07-20","2024-08-04","2024-08-07","2024-08-07","2024-07-08","2024-07-21","2024-08-11","2024-07-12"]
[null,"2024-08-11","2024-08-10","2024-08-10","2024-08-12","2024-07-21","2024-08-12","2024-07-29","2024-08-07","2024-07-21","2024-08-05","2024-08-08","2024-08-08","2024-07-09","2024-07-22","2024-08-12","2024-07-13"]
[null,"2024-08-12","2024-08-11","2024-08-11","2024-08-13","2024-07-22","2024-08-13","2024-07-30","2024-08-08","2024-07-22","2024-08-06","2024-08-09","2024-08-09","2024-07-10","2024-07-23","2024-08-13","2024-07-14"]
[null,"2024-08-13","2024-08-12","2024-08-12","2024-08-14","2024-07-23","2024-08-14","2024-07-31","2024-08-09","2024-07-23","2024-08-07","2024-08-10","2024-08-10","2024-07-11","2024-07-24","2024-08-14","2024-07-15"]
[null,"2024-08-14","2024-08-13","2024-08-13","2024-08-15","2024-07-24","2024-08-15","2024-08-01","2024-08-10","2024-07-24","2024-08-08","2024-08-11","2024-08-11","2024-07-12","2024-07-25","2024-08-15","2024-07-16"]
[null,"2024-08-15","2024-08-14","2024-08-14","2024-08-16","2024-07-25","2024-08-16","2024-08-02","2024-08-11","2024-07-25","2024-08-09","2024-08-12","2024-08-12","2024-07-13","2024-07-26","2024-08-16","2024-07-17"]
[null,"2024-08-16","2024-08-15","2024-08-15","2024-08-17","2024-07-26","2024-08-17","2024-08-03","2024-08-12","2024-07-26","2024-08-10","2024-08-13","2024-08-13","2024-07-14","2024-07-27","2024-08-17","2024-07-18"]
[null,"2024-08-17","2024-08-16","2024-08-16","2024-08-18","2024-07-27","2024-08-18","2024-08-04","2024-08-13","2024-07-27","2024-08-11","2024-08-14","2024-08-14","2024-07-15","2024-07-28","2024-08-18","2024-07-19"]
[null,"2024-08-18","2024-08-17","2024-08-17","2024-08-19","2024-07-28","2024-08-19","2024-08-05","2024-08-14","2024-07-28","2024-08-12","2024-08-15","2024-08-15","2024-07-16","2024-07-29","2024-08-19","2024-07-20"]
[null,"2024-08-19","2024-08-18","2024-08-18","2024-08-20","2024-07-29","2024-08-20","2024-08-06","2024-08-15","2024-07-29","2024-08-13","2024-08-16","2024-08-16","2024-07-17","2024-07-30","2024-08-20","2024-07-21"]
[null,"2024-08-20","2024-08-19","2024-08-19","2024-08-21","2024-07-30","2024-08-21","2024-08-07","2024-08-16","2024-07-30","2024-08-14","2024-08-17","2024-08-17","2024-07-18","2024-07-31","2024-08-21","2024-07-22"]
[null,"2024-08-21","2024-08-20","2024-08-20","2024-08-22","2024-07-31","2024-08-22","2024-08-08","2024-08-17","2024-07-31","2024-08-15","2024-08-18","2024-08-18","2024-07-19","2024-08-01","2024-08-22","2024-07-23"]
[null,"2024-08-22","2024-08-21","2024-08-21","2024-08-23","2024-08-01","2024-08-23","2024-08-09","2024-08-18","2024-08-01","2024-08-16","2024-08-19","2024-08-19","2024-07-20","2024-08-02","2024-08-23","2024-07-24"]
[null,"2024-08-23","2024-08-22","2024-08-22","2024-08-24","2024-08-02","2024-08-24","2024-08-10","2024-08-19","2024-08-02","2024-08-17","2024-08-20","2024-08-20","2024-07-21","2024-08-03","2024-08-24","2024-07-25"]
[null,"2024-08-24","2024-08-23","2024-08-23","2024-08-25","2024-10-04","2024-08-25","2024-08-11","2024-08-20","2024-08-03","2024-08-18","2024-08-21","2024-08-21","2024-07-22","2024-09-30","2024-08-25","2024-07-26"]
[null,"2024-08-25","2024-08-24","2024-08-24","2024-08-26","2024-10-05","2024-08-26","2024-08-12","2024-08-21","2024-10-04","2024-08-19","2024-08-22","2024-08-22","2024-07-23","2024-10-01","2024-08-26","2024-07-27"]
[null,"2024-08-26","2024-08-25","2024-08-25","2024-08-27","2024-10-06","2024-08-27","2024-08-13","2024-08-22","2024-10-05","2024-08-20","2024-08-23","2024-08-23","2024-07-24","2024-10-02","2024-08-27","2024-07-28"]
[null,"2024-08-27","2024-08-26","2024-08-26","2024-08-28","2024-10-07","2024-08-28","2024-08-14","2024-08-23","2024-10-06","2024-10-14","2024-10-14","2025-10-14","2024-07-25","2024-10-03","2024-08-28","2024-07-29"]
[null,"2024-08-28","2024-08-27","2024-08-27","2024-08-29","2024-10-08","2024-10-04","2024-08-15","2024-08-24","2024-10-07","2024-10-15","2024-10-15","2025-10-15","2024-07-26","2024-10-04","2024-08-29","2024-07-30"]
[null,"2024-08-29","2024-08-28","2024-08-28","2024-08-30","2024-10-09","2024-10-21","2024-08-16","2024-08-25","2024-10-08","2024-10-16","2024-10-16","2025-10-16","2024-07-27","2024-10-05","2024-08-30","2024-07-31"]
[null,"2024-08-30","2024-08-29","2024-08-29","2024-08-31","2024-10-10","2024-10-22","2024-08-17","2024-08-26","2024-10-09","2024-10-17","2024-10-17","2025-10-17","2024-07-28","2024-10-06","2024-08-31","2024-09-30"]
[null,"2024-08-31","2024-08-30","2024-08-30","2024-10-04","2024-10-11","2024-10-23","2024-08-18","2024-08-27","2024-10-10","2024-10-18","2024-10-18","2025-10-18","2024-07-29","2024-10-07","2024-10-04","2024-10-01"]
[null,"2024-09-01","2024-08-31","2024-10-04","2024-10-21","2024-10-12","2024-10-24","2024-08-19","2024-08-28","2024-10-11","2024-10-19","2024-10-19","2025-10-19","2024-07-30","2024-10-08","2024-10-21","2024-10-02"]
[null,"2024-09-02","2024-09-01","2024-10-21","2024-10-22","2024-10-13","2024-10-25","2024-08-20","2024-08-29","2024-10-12","2024-10-20","2024-10-20","2025-10-20","2024-07-31","2024-10-09","2024-10-22","2024-10-03"]
[null,"2024-09-03","2024-09-02","2024-10-22","2024-10-23","2024-10-14","2024-10-26","2024-08-21","2024-08-30","2024-10-13","2024-10-21","2024-10-21","2025-10-21","2024-08-01","2024-10-10","2024-10-23","2024-10-04"]
[null,"2024-09-04","2024-09-03","2024-10-23","2024-10-24","2024-10-15","2024-10-27","2024-08-22","2024-08-31","2024-10-14","2024-10-22","2024-10-22","2025-10-22","2024-08-02","2024-10-11","2024-10-24","2024-10-05"]
[null,"2024-09-05","2024-09-04","2024-10-24","2024-10-25","2024-10-16","2024-10-28","2024-08-23","2024-10-04","2024-10-15","2024-10-23","2024-10-23","2025-10-23","2024-10-07","2024-10-12","2024-10-25","2024-10-06"]
[null,"2024-09-06","2024-09-05","2024-10-25","2024-10-26","2024-10-17","2024-10-29","2024-10-14","2024-10-21","2024-10-16","2024-10-24","2024-10-24","2025-10-24","2024-10-08","2024-11-01","2024-10-26","2024-10-07"]
[null,"2024-09-07","2024-09-06","2024-10-26","2024-10-27","2024-10-18","2024-10-30","2024-10-15","2024-10-22","2024-10-17","2024-10-25","2024-10-25","2025-10-25","2024-10-09","2024-12-23","2024-10-27","2024-10-08"]
[null,"2024-10-28","2024-09-07","2024-10-27","2024-10-28","2024-10-19","2024-10-31","2024-10-16","2024-10-23","2024-10-18","2024-10-26","2024-12-23","2024-12-23","2024-10-10","2024-12-24","2024-10-28","2024-10-09"]
[null,"2024-10-29","2024-09-08","2024-10-28","2024-10-29","2024-11-01","2024-11-01","2024-10-17","2024-10-24","2024-10-19","2024-12-23","2024-12-24","2024-12-24","2024-10-11","2024-12-25","2024-10-29","2024-10-10"]
[null,"2024-10-30","2024-09-09","2024-10-29","2024-10-30","2024-12-23","2024-12-20","2024-10-18","2024-10-25","2024-11-01","2024-12-24","2024-12-25","2024-12-25","2024-10-12","2024-12-26","2024-10-30","2024-10-11"]
[null,"2024-12-23","2024-10-28","2024-10-30","2024-10-31","2024-12-24","2024-12-21","2024-10-19","2024-10-26","2024-12-23","2024-12-25","2024-12-26","2024-12-26","2024-10-13","2024-12-27","2024-10-31","2024-10-12"]
[null,"2024-12-24","2024-10-29","2024-10-31","2024-11-01","2024-12-25","2024-12-22","2024-10-20","2024-11-01","2024-12-24","2024-12-26","2024-12-27","2024-12-27","2024-10-14","2024-12-28","2024-11-01","2024-12-23"]
[null,"2024-12-25","2024-10-30","2024-11-01","2024-11-02","2024-12-26","2024-12-23","2024-10-21","2024-12-23","2024-12-25","2024-12-27","2024-12-28","2024-12-28","2024-10-15","2024-12-29","2024-12-19","2024-12-24"]
[null,"2024-12-26","2024-10-31","2024-11-02","2024-12-23","2024-12-27","2024-12-24","2024-10-22","2024-12-24","2024-12-26","2024-12-28","2024-12-29","2024-12-29","2024-10-16","2024-12-30","2024-12-20","2024-12-25"]
[null,"2024-12-27","2024-11-20","2024-12-23","2024-12-24","2024-12-28","2024-12-25","2024-10-23","2024-12-25","2024-12-27","2024-12-29","2024-12-30","2024-12-30","2024-10-17","2024-12-31","2024-12-21","2024-12-26"]
[null,"2024-12-28","2024-12-23","2024-12-24","2024-12-25","2024-12-29","2024-12-26","2024-10-24","2024-12-26","2024-12-28","2024-12-30","2024-12-31","2024-12-31","2024-10-18","2025-01-01","2024-12-22","2024-12-27"]
[null,"2024-12-29","2024-12-24","2024-12-25","2024-12-26","2024-12-30","2024-12-27","2024-10-25","2024-12-27","2024-12-29","2024-12-31","2025-01-01","2025-01-01","2024-10-19","2025-01-02","2024-12-23","2024-12-28"]
[null,"2024-12-30","2024-12-25","2024-12-26","2024-12-27","2024-12-31","2024-12-28","2024-12-23","2024-12-28","2024-12-30","2025-01-01","2025-01-02","2025-01-02","2024-12-23","2025-01-03","2024-12-24","2024-12-29"]
[null,"2024-12-31","2024-12-26","2024-12-27","2024-12-28","2025-01-01","2024-12-29","2024-12-24","2024-12-29","2024-12-31","2025-01-02","2025-01-03","2025-01-03","2024-12-24","2025-01-04","2024-12-25","2024-12-30"]
[null,"2025-01-01","2024-12-27","2024-12-28","2024-12-29","2025-01-02","2024-12-30","2024-12-25","2024-12-30","2025-01-01","2025-01-03","2025-01-04",null,"2024-12-25",null,"2024-12-26","2024-12-31"]
[null,"2025-01-02","2024-12-28","2024-12-29","2024-12-30","2025-01-03","2024-12-31","2024-12-26","2024-12-31","2025-01-02","2025-01-04","2025-01-05",null,"2024-12-26",null,"2024-12-27","2025-01-01"]
[null,"2025-01-03","2024-12-29","2024-12-30","2024-12-31","2025-01-04","2025-01-01","2024-12-27","2025-01-01","2025-01-03","2025-01-05","2025-01-06",null,"2024-12-27",null,"2024-12-28","2025-01-02"]
[null,"2025-01-04","2024-12-30","2024-12-31",null,null,"2025-01-02","2024-12-28","2025-01-02","2025-01-04","2025-01-06","2025-01-07",null,"2024-12-28",null,"2024-12-29","2025-01-03"]
[null,null,"2024-12-31",null,null,null,"2025-01-03","2024-12-29","2025-01-03",null,null,"2025-01-08",null,"2024-12-29",null,"2024-12-30"]
[null,null,"2025-01-01",null,null,null,null,"2024-12-30","2025-01-04",null,null,null,null,"2024-12-30",null,"2024-12-31"]
[null,null,"2025-01-02",null,null,null,null,"2024-12-31","2025-01-05",null,null,null,null,"2024-12-31",null,"2025-01-01"]
[null,null,"2025-01-03",null,null,null,null,"2025-01-01","2025-01-06",null,null,null,null,"2025-01-01",null,"2025-01-02"]
[null,null,null,null,null,null,null,"2025-01-02",null,null,null,null,null,"2025-01-02",null,"2025-01-03"]
[null,null,null,null,null,null,null,"2025-01-03",null,null,null,null,null,"2025-01-03",null,"2025-01-04"]
[null,null,null,null,null,null,null,"2025-01-04",null,null,null,null,null,null,null,"2025-01-05"]
[null,null,null,null,null,null,null,"2025-01-05",null,null,null,null,null,null,null,"2025-01-06"]
[null,null,null,null,null,null,null,"2025-01-06",null,null,null,null,null,null,null,"2025-01-07"]

{"sheet":"Daten","index":5,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,{"$f":"YEAR(Urlaubsplaner!B2)","v":2024},null,"Wochentag",null,"Öffentliche Variablen"]
[null,{"$f":"DATE(B2,1,1)","v":"2024-01-01"},"Neujahr",{"$f":"WEEKDAY(B3)","v":2},null,"ATW","Arbeitstage/Woche"]
[null,{"$f":"DATE(B2,1,6)","v":"2024-01-06"},"Drei Könige",7,null,"ABT","Anzahl Abteilungen"]
[null,{"$f":"ostern(B2)-2","v":"2024-03-29"},"Karfreitag",6,null,"MAA","Mitarbeiter pro Abteilung"]
[null,{"$f":"ostern(B2)+1","v":"2024-04-01"},"Ostermontag",2,null,"MAGes","Mitarbeiter gesamt"]
[null,{"$f":"DATE(B2,5,1)","v":"2024-05-01"},"Tag der Arbeit",4,null,"Jahr","aktuelles Jahr"]
[null,{"$f":"ostern(B2)+39","v":"2024-05-09"},"Himmelfahrt",5]
[null,{"$f":"ostern(B2)+50","v":"2024-05-20"},"Pfingstmontag",2]
[null,{"$f":"ostern(B2)+60","v":"2024-05-30"},"Fronleichnam",5]
[null,{"$f":"DATE(B2,8,15)","v":"2024-08-15"},"Mariä Empfängnis",5]
[null,{"$f":"DATE(B2,10,3)","v":"2024-10-03"},"Nationalfeiertag",5]
[null,{"$f":"DATE(B2,10,31)","v":"2024-10-31"},"Reformationstag",5]
[null,{"$f":"DATE(B2,11,1)","v":"2024-11-01"},"Allerheiligen",6]
[null,{"$f":"IF(D14=1,DATE(B2,11,18),IF(D14=2,DATE(B2,11,17),IF(D14=3,DATE(B2,11,16),IF(D14=4,DATE(B2,11,15),IF(D14=5,DATE(B2,11,21),IF(D14=6,DATE(B2,11,20),DATE(B2,11,19)))))))","v":"2024-11-20"},"Buß- und Bettag",4]
[null,{"$f":"DATE(B2,12,24)","v":"2024-12-24"},"Heiligabend",3]
[null,{"$f":"DATE(B2,12,25)","v":"2024-12-25"},"1. Weihnachtstag",4]
[null,{"$f":"DATE(B2,12,26)","v":"2024-12-26"},"2. Weihnachtstag",5]
[null,{"$f":"DATE(B2,12,31)","v":"2024-12-31"},"Silvester",3]
[null,{"$f":"DATE(B2,12,31)+1","v":"2025-01-01"},"Neujahr",4]
[null,{"$f":"DATE(B2,3,8)","v":"2024-03-08"},"Frauentag",6]

{"sheet":"Import","index":6,"n_rows":386,"n_cols":16,"rows_kept":386,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Jahr","Arb.-Tage/Woche","Bundesland"]
[null,null,null,null,null,null,2012,5,"NRW"]
[null,null,null,null,"Abteilungen",null,"Einkauf","Verkauf","Konstruktion","Kalkulation","Buchhaltung","Werkstatt"]
[null,null,null,null,"Urlaubsanspruch",null,30.5,40,null,null,null,null,null,null,null,50]
[null,null,null,null,"Mitarbeiter",null,"Beispiel, Sven","Beispiel, Tanja",null,null,null,null,null,null,null,"Test, Marc"]
[null,null,null,null,null,"01.01.2012"]
[null,null,null,null,null,"02.01.2012"]
[null,null,null,null,null,"03.01.2012"]
[null,null,null,null,null,"04.01.2012"]
[null,null,null,null,null,"05.01.2012"]
[null,null,null,null,null,"06.01.2012"]
[null,null,null,null,null,"07.01.2012"]
[null,null,null,null,null,"08.01.2012"]
[null,null,null,null,null,"09.01.2012"]
[null,null,null,null,null,"10.01.2012"]
[null,null,null,null,null,"11.01.2012"]
[null,null,null,null,null,"12.01.2012"]
[null,null,null,null,null,"13.01.2012"]
[null,null,null,null,null,"14.01.2012"]
[null,null,null,null,null,"15.01.2012"]
[null,null,null,null,null,"16.01.2012"]
[null,null,null,null,null,"17.01.2012"]
[null,null,null,null,null,"18.01.2012"]
[null,null,null,null,null,"19.01.2012"]
[null,null,null,null,null,"20.01.2012"]
[null,null,null,null,null,"21.01.2012"]
[null,null,null,null,null,"22.01.2012"]
[null,null,null,null,null,"23.01.2012"]
[null,null,null,null,null,"24.01.2012"]
[null,null,null,null,null,"25.01.2012"]
[null,null,null,null,null,"26.01.2012"]
[null,null,null,null,null,"27.01.2012"]
[null,null,null,null,null,"28.01.2012"]
[null,null,null,null,null,"29.01.2012"]
[null,null,null,null,null,"30.01.2012"]
[null,null,null,null,null,"31.01.2012"]
[null,null,null,null,null,"01.02.2012"]
[null,null,null,null,null,"02.02.2012"]
[null,null,null,null,null,"03.02.2012"]
[null,null,null,null,null,"04.02.2012"]
[null,null,null,null,null,"05.02.2012"]
[null,null,null,null,null,"06.02.2012"]
[null,null,null,null,null,"07.02.2012"]
[null,null,null,null,null,"08.02.2012"]
[null,null,null,null,null,"09.02.2012"]
[null,null,null,null,null,"10.02.2012"]
[null,null,null,null,null,"11.02.2012"]
[null,null,null,null,null,"12.02.2012"]
[null,null,null,null,null,"13.02.2012"]
[null,null,null,null,null,"14.02.2012"]
[null,null,null,null,null,"15.02.2012"]
[null,null,null,null,null,"16.02.2012"]
[null,null,null,null,null,"17.02.2012"]
[null,null,null,null,null,"18.02.2012"]
[null,null,null,null,null,"19.02.2012"]
[null,null,null,null,null,"20.02.2012"]
[null,null,null,null,null,"21.02.2012"]
[null,null,null,null,null,"22.02.2012"]
[null,null,null,null,null,"23.02.2012"]
[null,null,null,null,null,"24.02.2012"]
[null,null,null,null,null,"25.02.2012"]
[null,null,null,null,null,"26.02.2012"]
[null,null,null,null,null,"27.02.2012"]
[null,null,null,null,null,"28.02.2012"]
[null,null,null,null,null,"29.02.2012"]
[null,null,null,null,null,"01.03.2012"]
[null,null,null,null,null,"02.03.2012"]
[null,null,null,null,null,"03.03.2012"]
[null,null,null,null,null,"04.03.2012"]
[null,null,null,null,null,"05.03.2012"]
[null,null,null,null,null,"06.03.2012"]
[null,null,null,null,null,"07.03.2012"]
[null,null,null,null,null,"08.03.2012"]
[null,null,null,null,null,"09.03.2012"]
[null,null,null,null,null,"10.03.2012"]
[null,null,null,null,null,"11.03.2012"]
[null,null,null,null,null,"12.03.2012"]
[null,null,null,null,null,"13.03.2012"]
[null,null,null,null,null,"14.03.2012"]
[null,null,null,null,null,"15.03.2012"]
[null,null,null,null,null,"16.03.2012"]
[null,null,null,null,null,"17.03.2012"]
[null,null,null,null,null,"18.03.2012"]
[null,null,null,null,null,"19.03.2012"]
[null,null,null,null,null,"20.03.2012"]
[null,null,null,null,null,"21.03.2012"]
[null,null,null,null,null,"22.03.2012"]
[null,null,null,null,null,"23.03.2012"]
[null,null,null,null,null,"24.03.2012"]
[null,null,null,null,null,"25.03.2012"]
[null,null,null,null,null,"26.03.2012"]
[null,null,null,null,null,"27.03.2012"]
[null,null,null,null,null,"28.03.2012"]
[null,null,null,null,null,"29.03.2012"]
[null,null,null,null,null,"30.03.2012"]
[null,null,null,null,null,"31.03.2012"]
[null,null,null,null,null,"01.04.2012"]
[null,null,null,null,null,"02.04.2012"]
[null,null,null,null,null,"03.04.2012"]
[null,null,null,null,null,"04.04.2012"]
[null,null,null,null,null,"05.04.2012"]
[null,null,null,null,null,"06.04.2012"]
[null,null,null,null,null,"07.04.2012"]
[null,null,null,null,null,"08.04.2012"]
[null,null,null,null,null,"09.04.2012"]
[null,null,null,null,null,"10.04.2012"]
[null,null,null,null,null,"11.04.2012"]
[null,null,null,null,null,"12.04.2012"]
[null,null,null,null,null,"13.04.2012"]
[null,null,null,null,null,"14.04.2012"]
[null,null,null,null,null,"15.04.2012"]
[null,null,null,null,null,"16.04.2012"]
[null,null,null,null,null,"17.04.2012"]
[null,null,null,null,null,"18.04.2012"]
[null,null,null,null,null,"19.04.2012"]
[null,null,null,null,null,"20.04.2012"]
[null,null,null,null,null,"21.04.2012"]
[null,null,null,null,null,"22.04.2012"]
[null,null,null,null,null,"23.04.2012"]
[null,null,null,null,null,"24.04.2012"]
[null,null,null,null,null,"25.04.2012"]
[null,null,null,null,null,"26.04.2012"]
[null,null,null,null,null,"27.04.2012"]
[null,null,null,null,null,"28.04.2012"]
[null,null,null,null,null,"29.04.2012"]
[null,null,null,null,null,"30.04.2012"]
[null,null,null,null,null,"01.05.2012"]
[null,null,null,null,null,"02.05.2012"]
[null,null,null,null,null,"03.05.2012"]
[null,null,null,null,null,"04.05.2012"]
[null,null,null,null,null,"05.05.2012"]
[null,null,null,null,null,"06.05.2012"]
[null,null,null,null,null,"07.05.2012"]
[null,null,null,null,null,"08.05.2012"]
[null,null,null,null,null,"09.05.2012"]
[null,null,null,null,null,"10.05.2012"]
[null,null,null,null,null,"11.05.2012"]
[null,null,null,null,null,"12.05.2012"]
[null,null,null,null,null,"13.05.2012"]
[null,null,null,null,null,"14.05.2012"]
[null,null,null,null,null,"15.05.2012"]
[null,null,null,null,null,"16.05.2012"]
[null,null,null,null,null,"17.05.2012"]
[null,null,null,null,null,"18.05.2012"]
[null,null,null,null,null,"19.05.2012"]
[null,null,null,null,null,"20.05.2012"]
[null,null,null,null,null,"21.05.2012"]
[null,null,null,null,null,"22.05.2012"]
[null,null,null,null,null,"23.05.2012"]
[null,null,null,null,null,"24.05.2012"]
[null,null,null,null,null,"25.05.2012"]
[null,null,null,null,null,"26.05.2012"]
[null,null,null,null,null,"27.05.2012"]
[null,null,null,null,null,"28.05.2012"]
[null,null,null,null,null,"29.05.2012"]
[null,null,null,null,null,"30.05.2012"]
[null,null,null,null,null,"31.05.2012"]
[null,null,null,null,null,"01.06.2012"]
[null,null,null,null,null,"02.06.2012"]
[null,null,null,null,null,"03.06.2012"]
[null,null,null,null,null,"04.06.2012"]
[null,null,null,null,null,"05.06.2012"]
[null,null,null,null,null,"06.06.2012"]
[null,null,null,null,null,"07.06.2012"]
[null,null,null,null,null,"08.06.2012"]
[null,null,null,null,null,"09.06.2012"]
[null,null,null,null,null,"10.06.2012"]
[null,null,null,null,null,"11.06.2012"]
[null,null,null,null,null,"12.06.2012"]
[null,null,null,null,null,"13.06.2012"]
[null,null,null,null,null,"14.06.2012"]
[null,null,null,null,null,"15.06.2012"]
[null,null,null,null,null,"16.06.2012"]
[null,null,null,null,null,"17.06.2012"]
[null,null,null,null,null,"18.06.2012"]
[null,null,null,null,null,"19.06.2012"]
[null,null,null,null,null,"20.06.2012"]
[null,null,null,null,null,"21.06.2012"]
[null,null,null,null,null,"22.06.2012"]
[null,null,null,null,null,"23.06.2012"]
[null,null,null,null,null,"24.06.2012"]
[null,null,null,null,null,"25.06.2012"]
[null,null,null,null,null,"26.06.2012"]
[null,null,null,null,null,"27.06.2012"]
[null,null,null,null,null,"28.06.2012"]
[null,null,null,null,null,"29.06.2012"]
[null,null,null,null,null,"30.06.2012"]
[null,null,null,null,null,"01.07.2012"]
[null,null,null,null,null,"02.07.2012"]
[null,null,null,null,null,"03.07.2012"]
[null,null,null,null,null,"04.07.2012"]
[null,null,null,null,null,"05.07.2012"]
[null,null,null,null,null,"06.07.2012"]
[null,null,null,null,null,"07.07.2012"]
[null,null,null,null,null,"08.07.2012"]
[null,null,null,null,null,"09.07.2012"]
[null,null,null,null,null,"10.07.2012"]
[null,null,null,null,null,"11.07.2012"]
[null,null,null,null,null,"12.07.2012"]
[null,null,null,null,null,"13.07.2012"]
[null,null,null,null,null,"14.07.2012"]
[null,null,null,null,null,"15.07.2012"]
[null,null,null,null,null,"16.07.2012"]
[null,null,null,null,null,"17.07.2012"]
[null,null,null,null,null,"18.07.2012"]
[null,null,null,null,null,"19.07.2012"]
[null,null,null,null,null,"20.07.2012"]
[null,null,null,null,null,"21.07.2012"]
[null,null,null,null,null,"22.07.2012"]
[null,null,null,null,null,"23.07.2012"]
[null,null,null,null,null,"24.07.2012"]
[null,null,null,null,null,"25.07.2012"]
[null,null,null,null,null,"26.07.2012"]
[null,null,null,null,null,"27.07.2012"]
[null,null,null,null,null,"28.07.2012"]
[null,null,null,null,null,"29.07.2012"]
[null,null,null,null,null,"30.07.2012"]
[null,null,null,null,null,"31.07.2012"]
[null,null,null,null,null,"01.08.2012"]
[null,null,null,null,null,"02.08.2012"]
[null,null,null,null,null,"03.08.2012"]
[null,null,null,null,null,"04.08.2012"]
[null,null,null,null,null,"05.08.2012"]
[null,null,null,null,null,"06.08.2012"]
[null,null,null,null,null,"07.08.2012"]
[null,null,null,null,null,"08.08.2012"]
[null,null,null,null,null,"09.08.2012"]
[null,null,null,null,null,"10.08.2012"]
[null,null,null,null,null,"11.08.2012"]
[null,null,null,null,null,"12.08.2012"]
[null,null,null,null,null,"13.08.2012"]
[null,null,null,null,null,"14.08.2012"]
[null,null,null,null,null,"15.08.2012"]
[null,null,null,null,null,"16.08.2012","F½","F½"]
[null,null,null,null,null,"17.08.2012","F½","F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"18.08.2012"]
[null,null,null,null,null,"19.08.2012"]
[null,null,null,null,null,"20.08.2012","F½","F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"21.08.2012","F½","F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"22.08.2012","F½","F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"23.08.2012","F½","F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"24.08.2012",null,"F½",null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"25.08.2012"]
[null,null,null,null,null,"26.08.2012"]
[null,null,null,null,null,"27.08.2012",null,null,null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"28.08.2012",null,null,null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"29.08.2012",null,null,null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"30.08.2012",null,null,null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"31.08.2012","F½",null,null,null,null,null,null,null,null,"U"]
[null,null,null,null,null,"01.09.2012"]
[null,null,null,null,null,"02.09.2012"]
[null,null,null,null,null,"03.09.2012","F½"]
[null,null,null,null,null,"04.09.2012","F½"]
[null,null,null,null,null,"05.09.2012","F½","F½"]
[null,null,null,null,null,"06.09.2012","F½","F½"]
[null,null,null,null,null,"07.09.2012",null,"F½"]
[null,null,null,null,null,"08.09.2012"]
[null,null,null,null,null,"09.09.2012"]
[null,null,null,null,null,"10.09.2012"]
[null,null,null,null,null,"11.09.2012"]
[null,null,null,null,null,"12.09.2012"]
[null,null,null,null,null,"13.09.2012"]
[null,null,null,null,null,"14.09.2012"]
[null,null,null,null,null,"15.09.2012"]
[null,null,null,null,null,"16.09.2012"]
[null,null,null,null,null,"17.09.2012"]
[null,null,null,null,null,"18.09.2012"]
[null,null,null,null,null,"19.09.2012","U"]
[null,null,null,null,null,"20.09.2012","U"]
[null,null,null,null,null,"21.09.2012","U"]
[null,null,null,null,null,"22.09.2012"]
[null,null,null,null,null,"23.09.2012"]
[null,null,null,null,null,"24.09.2012","U"]
[null,null,null,null,null,"25.09.2012"]
[null,null,null,null,null,"26.09.2012","U"]
[null,null,null,null,null,"27.09.2012","U"]
[null,null,null,null,null,"28.09.2012","U"]
[null,null,null,null,null,"29.09.2012"]
[null,null,null,null,null,"30.09.2012"]
[null,null,null,null,null,"01.10.2012","U"]
[null,null,null,null,null,"02.10.2012"]
[null,null,null,null,null,"03.10.2012"]
[null,null,null,null,null,"04.10.2012"]
[null,null,null,null,null,"05.10.2012"]
[null,null,null,null,null,"06.10.2012"]
[null,null,null,null,null,"07.10.2012"]
[null,null,null,null,null,"08.10.2012"]
[null,null,null,null,null,"09.10.2012"]
[null,null,null,null,null,"10.10.2012"]
[null,null,null,null,null,"11.10.2012"]
[null,null,null,null,null,"12.10.2012"]
[null,null,null,null,null,"13.10.2012"]
[null,null,null,null,null,"14.10.2012"]
[null,null,null,null,null,"15.10.2012"]
[null,null,null,null,null,"16.10.2012"]
[null,null,null,null,null,"17.10.2012"]
[null,null,null,null,null,"18.10.2012"]
[null,null,null,null,null,"19.10.2012"]
[null,null,null,null,null,"20.10.2012"]
[null,null,null,null,null,"21.10.2012"]
[null,null,null,null,null,"22.10.2012"]
[null,null,null,null,null,"23.10.2012"]
[null,null,null,null,null,"24.10.2012"]
[null,null,null,null,null,"25.10.2012"]
[null,null,null,null,null,"26.10.2012"]
[null,null,null,null,null,"27.10.2012"]
[null,null,null,null,null,"28.10.2012"]
[null,null,null,null,null,"29.10.2012"]
[null,null,null,null,null,"30.10.2012"]
[null,null,null,null,null,"31.10.2012"]
[null,null,null,null,null,"01.11.2012"]
[null,null,null,null,null,"02.11.2012"]
[null,null,null,null,null,"03.11.2012"]
[null,null,null,null,null,"04.11.2012"]
[null,null,null,null,null,"05.11.2012"]
[null,null,null,null,null,"06.11.2012"]
[null,null,null,null,null,"07.11.2012"]
[null,null,null,null,null,"08.11.2012"]
[null,null,null,null,null,"09.11.2012"]
[null,null,null,null,null,"10.11.2012"]
[null,null,null,null,null,"11.11.2012"]
[null,null,null,null,null,"12.11.2012"]
[null,null,null,null,null,"13.11.2012"]
[null,null,null,null,null,"14.11.2012"]
[null,null,null,null,null,"15.11.2012"]
[null,null,null,null,null,"16.11.2012"]
[null,null,null,null,null,"17.11.2012"]
[null,null,null,null,null,"18.11.2012"]
[null,null,null,null,null,"19.11.2012"]
[null,null,null,null,null,"20.11.2012"]
[null,null,null,null,null,"21.11.2012"]
[null,null,null,null,null,"22.11.2012"]
[null,null,null,null,null,"23.11.2012"]
[null,null,null,null,null,"24.11.2012"]
[null,null,null,null,null,"25.11.2012"]
[null,null,null,null,null,"26.11.2012"]
[null,null,null,null,null,"27.11.2012"]
[null,null,null,null,null,"28.11.2012"]
[null,null,null,null,null,"29.11.2012"]
[null,null,null,null,null,"30.11.2012"]
[null,null,null,null,null,"01.12.2012"]
[null,null,null,null,null,"02.12.2012"]
[null,null,null,null,null,"03.12.2012"]
[null,null,null,null,null,"04.12.2012"]
[null,null,null,null,null,"05.12.2012"]
[null,null,null,null,null,"06.12.2012"]
[null,null,null,null,null,"07.12.2012"]
[null,null,null,null,null,"08.12.2012"]
[null,null,null,null,null,"09.12.2012"]
[null,null,null,null,null,"10.12.2012"]
[null,null,null,null,null,"11.12.2012"]
[null,null,null,null,null,"12.12.2012"]
[null,null,null,null,null,"13.12.2012"]
[null,null,null,null,null,"14.12.2012"]
[null,null,null,null,null,"15.12.2012"]
[null,null,null,null,null,"16.12.2012"]
[null,null,null,null,null,"17.12.2012"]
[null,null,null,null,null,"18.12.2012"]
[null,null,null,null,null,"19.12.2012"]
[null,null,null,null,null,"20.12.2012"]
[null,null,null,null,null,"21.12.2012"]
[null,null,null,null,null,"22.12.2012"]
[null,null,null,null,null,"23.12.2012"]
[null,null,null,null,null,"24.12.2012"]
[null,null,null,null,null,"25.12.2012"]
[null,null,null,null,null,"26.12.2012"]
[null,null,null,null,null,"27.12.2012"]
[null,null,null,null,null,"28.12.2012"]
[null,null,null,null,null,"29.12.2012"]
[null,null,null,null,null,"30.12.2012"]
[null,null,null,null,null,"31.12.2012"]
[null,null,null,null,null,"01.01.2013"]
[null,null,null,null,null,"02.01.2013"]
[null,null,null,null,null,"03.01.2013"]
[null,null,null,null,null,"04.01.2013"]
[null,null,null,null,null,"05.01.2013"]
[null,null,null,null,null,"06.01.2013"]
[null,null,null,null,null,"07.01.2013"]
[null,null,null,null,null,"08.01.2013"]
[null,null,null,null,null,"09.01.2013"]